{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["calculo","datos (no manipular esta hoja)"],"not_rendered":{"charts":1,"images":17,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"calculo","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Instalación","Extractores Ventiladores"]
["cliente","Ritrama"]
[]
["Precio kW",null,null,{"$f":"'datos (no manipular esta hoja)'!$B$21","v":0.08},null,"Motor kW",null,null,{"$f":"'datos (no manipular esta hoja)'!$G$42","v":18.5}]
["Frecuencia Alta",null,null,{"$f":"'datos (no manipular esta hoja)'!$D$60","v":48},null,"Nominal motor",null,null,{"$f":"'datos (no manipular esta hoja)'!$I$31","v":50}]
["Frecuencia Baja",null,null,{"$f":"'datos (no manipular esta hoja)'!$E$60","v":50},null,"Coef. Motor",null,null,{"$f":"'datos (no manipular esta hoja)'!$K$24","v":0.75},null,{"$f":"I5*I7","v":13.875}]
[null,null,null,null,null,"Cantidad",null,null,14]
[]
[null,"Alta",12,12,12,12,12,12,12]
[null,"Baja",12,12,12,12,12,12,12]
[null,null,"LUNES","MARTES","MIÉRCOLES","JUEVES","VIERNES","SÁBADO","DOMINGO"]
[]
[]
[null,null,null,"Semana","Horas Frecuencia Baja",null,{"$f":"SUM(C11:I11)","v":84}]
[null,null,null,null,"Horas Frecuencia Alta",null,{"$f":"SUM(C10:I10)","v":84}]
[]
[null,null,null,"Mes","Horas Frecuencia Baja",null,{"$f":"G15*4","v":336}]
[null,null,null,null,"Horas Frecuencia Alta",null,{"$f":"G16*4","v":336}]
[]
[null,null,null,"Año","Horas Frecuencia Baja",null,{"$f":"G18*12","v":4032}]
[null,null,null,null,"Horas Frecuencia Alta",null,{"$f":"G19*12","v":4032}]
[]
[null,null,{"$f":"\"Descontar horas Baja  (Dias \"&K24&\")\"","v":"Descontar horas Baja  (Dias 0)"},null,null,null,0,null,null,null,{"$f":"G24/24","v":0}]
[null,null,{"$f":"\"Descontar Horas Alta, Dias (\" & K25 &\")\"","v":"Descontar Horas Alta, Dias (0)"},null,null,null,0,null,null,null,{"$f":"G25/24","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Instalación",{"$f":"$B$2","v":"Extractores Ventiladores"}]
[null,null,null,"Cliente",{"$f":"$B$3","v":"Ritrama"}]
[null,null,null,"Total horas Baja  Frecuencia Año",null,null,{"$f":"G21-G24","v":4032},null,{"$f":"G36/24 & \" Dias\"","v":"168 Dias"}]
[null,null,null,"Total horas Alta frecuencia Año",null,null,{"$f":"G22-G25","v":4032},null,{"$f":"G37/24 & \" Dias\"","v":"168 Dias"}]
[null,null,null,"Total Horas Trabajando con Variador",null,null,{"$f":"G37+G36","v":8064},null,{"$f":"G38/24 & \" Dias\"","v":"336 Dias"}]
[]
["KW  consumidos por el en accionamiento directo (motor sin Variador)",null,null,null,null,null,null,null,{"$f":"G36*K7+G37*K7","v":111888}]
["Coste energético en Euros del consumo del motor sin Variador",null,null,null,null,null,null,null,{"$f":"I40*D5","v":8951.0400000000009}]
[]
[{"$f":"\"ALTA - kW consumidos por el motor funcionando a una frecuencia de \" & D7 &  \" hertz a través del variador durante \" & I36","v":"ALTA - kW consumidos por el motor funcionando a una frecuencia de 50 hertz a través del variador durante 168 Dias"},null,null,null,null,null,null,null,{"$f":"K43*(D7/I6)^3","v":55944},null,{"$f":"G36*K7","v":55944}]
[{"$f":"\"Coste energético en Euros del consumo del Motor a la frecuencia de \" & D7 & \" Hertz\"","v":"Coste energético en Euros del consumo del Motor a la frecuencia de 50 Hertz"},null,null,null,null,null,null,null,{"$f":"I43*D5","v":4475.5200000000004}]
[]
[{"$f":"\"BAJA - kW consumjidos por el motor funcionando a una frecuencia de \" & D6 &  \" hertz a través del variador durante \" & I37","v":"BAJA - kW consumjidos por el motor funcionando a una frecuencia de 48 hertz a través del variador durante 168 Dias"},null,null,null,null,null,null,null,{"$f":"K46*(D6/I6)^3","v":49495.670784000002},null,{"$f":"G37*K7","v":55944}]
[{"$f":"\"Coste energético en Euros del consumo del Motor a la frecuencia de \" & D6 & \" Hertz\"","v":"Coste energético en Euros del consumo del Motor a la frecuencia de 48 Hertz"},null,null,null,null,null,null,null,{"$f":"I46*D5","v":3959.6536627200003}]
[null,null,null,null,null,{"$f":"I40","v":111888}]
[null,null,null,null,null,{"$f":"I43","v":55944}]
["Coste total con Variador",null,null,null,null,{"$f":"I46","v":49495.670784000002},null,null,{"$f":"I44+I47","v":8435.1736627200007}]
["Ahorro Año (Si fuese sólo 1 variador)",null,null,null,null,null,null,null,{"$f":"I41-I50","v":515.86633728000015}]
[]
[{"$f":"\"Total ahorro en un año por \" & I8 & \" Variadores Instalados \"","v":"Total ahorro en un año por 14 Variadores Instalados "},null,null,null,null,null,null,null,{"$f":"I51*I8","v":7222.1287219200021}]
[]
["  Sin Variador Coste"]
[]
["  Coste Alta (Variador)"]
[]
["  Coste Baja (Variador)"]

{"sheet":"datos (no manipular esta hoja)","index":1,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"pr kw",null,"frecuencia",null,null,"kw motor",null,"nom motor",null,"Coef.Motor",null,"Cantidad"]
[null,0.08,null,10,null,null,1.5,null,50,null,0.5,null,1]
[null,0.09,null,11,null,null,2.2000000000000002,null,60,null,0.55000000000000004,null,2]
[null,0.1,null,12,null,null,3.7,null,null,null,0.6,null,3]
[null,0.11,null,13,null,null,5.5,null,null,null,0.65,null,4]
[null,0.12,null,14,null,null,7.5,null,null,null,0.7,null,5]
[null,0.13,null,15,null,null,11,null,null,null,0.75,null,6]
[null,0.14000000000000001,null,16,null,null,15,null,null,null,0.8,null,7]
[null,0.15,null,17,null,null,18.5,null,null,null,0.85,null,8]
[null,0.16,null,18,null,null,22,null,null,null,0.9,null,9]
[null,0.17,null,19,null,null,30,null,null,null,0.95,null,10]
[null,0.18,null,20,null,null,37,null,null,null,1,null,11]
[null,0.19,null,21,null,null,45,null,null,null,null,null,12]
[null,null,null,22,null,null,55,null,null,null,null,null,13]
[null,1,null,23,null,null,75,null,null,null,null,null,14]
[null,{"$f":"INDEX(B7:B18,B20)","v":0.08},null,24,null,null,90,null,null,null,null,null,15]
[null,null,null,25,null,null,110,null,null,null,6,null,16]
[null,null,null,26,null,null,132,null,null,null,null,null,17]
[null,null,null,27,null,null,160,null,null,null,{"$f":"INDEX(K7:K17,K22)","v":0.75},null,18]
[null,null,null,28,null,null,190,null,null,null,null,null,19]
[null,null,null,29,null,null,210,null,null,null,null,null,20]
[null,null,null,30,null,null,232,null,null,null,null,null,21]
[null,null,null,31,null,null,370,null,null,null,null,null,22]
[null,null,null,32,null,null,500,null,1,null,null,null,23]
[null,null,null,33,null,null,null,null,null,null,null,null,24]
[null,null,null,34,null,null,null,null,{"$f":"INDEX(I7:I8,I29)","v":50},null,null,null,25]
[null,null,null,35,null,null,null,null,null,null,null,null,26]
[null,null,null,36,null,null,null,null,null,null,null,null,27]
[null,null,null,37,null,null,null,null,null,null,null,null,28]
[null,null,null,38,null,null,null,null,null,null,null,null,29]
[null,null,null,39,null,null,null,null,null,null,null,null,30]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44,null,null,8]
[null,null,null,45,null,null,{"$f":"INDEX(G7:G29,G41)","v":18.5}]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]
[null,null,null,51]
[null,null,null,52]
[null,null,null,53]
[null,null,null,54]
[null,null,null,55]
[null,null,null,56]
[null,null,null,57]
[null,null,null,58]
[null,null,null,59]
[null,null,null,60]
[]
[null,null,null,39,41]
[null,null,null,{"$f":"INDEX(D7:D57,D59)","v":48},{"$f":"INDEX(D7:D57,E59)","v":50}]